package com.mingda.weathermagiccenter.mapper;

import com.mingda.weathermagiccenter.pojo.WsEquisurfaceOrg;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author Administrator
* @description 针对表【ws_equisurface_org(组织机构)】的数据库操作Mapper
* @createDate 2025-06-05 09:27:49
* @Entity com.mingda.weathermagiccenter.pojo.WsEquisurfaceOrg
*/
@Mapper
public interface WsEquisurfaceOrgMapper extends BaseMapper<WsEquisurfaceOrg> {

    	@Select({ "<script>",
			"SELECT orgid, orgname, flag, ST_AsGeoJSON (org_geom ) :: json AS org_geom",
			"FROM ws_equisurface_org WHERE flag = '1' ",
		"</script>" })
	    public List<WsEquisurfaceOrg> getListGeometry();
}




